USE clothing 

go 

IF EXISTS(SELECT * 
          FROM   sys.objects 
          WHERE  object_id = Object_id(N'post_info') 
                 AND type IN ( N'U' )) 
  BEGIN 
      DROP TABLE post_info 
  END 

go 

CREATE TABLE post_info 
  ( 
     pid         VARCHAR(10) NOT NULL, 
     sectionname NVARCHAR(10) NOT NULL, 
     PRIMARY KEY CLUSTERED ( pid ASC )WITH (ignore_dup_key=OFF) ON [primary] 
  ) 
ON [primary] 

go 